package com.gxa.dao;
import com.gxa.pojo.Institutional;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface InstitutionalMapper {
@Select("select * from institutional ")
    public List<Institutional> selectInstitution();
@Delete("delete  from institutional where institutional_name=#{institutional_name}")
    public int deleteInstitutional(String institutional_name);


@Insert("insert into institutional values (#{institutional_name},#{institutional_type},#{institutional_id},#{institutional_creationtime},#{institutional_refreshtime},#{institutional_operate})")
    public int insertInstitutional(Institutional institutional);
}
